package com.knowif.pojo;

import java.util.ArrayList;
import java.util.List;

public class SchoolExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public SchoolExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    /**
     * 
     * 
     * @author wcyong
     * 
     * @date 2019-06-14
     */
    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andIdIsNull() {
            addCriterion("id is null");
            return (Criteria) this;
        }

        public Criteria andIdIsNotNull() {
            addCriterion("id is not null");
            return (Criteria) this;
        }

        public Criteria andIdEqualTo(Integer value) {
            addCriterion("id =", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotEqualTo(Integer value) {
            addCriterion("id <>", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThan(Integer value) {
            addCriterion("id >", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("id >=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThan(Integer value) {
            addCriterion("id <", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThanOrEqualTo(Integer value) {
            addCriterion("id <=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdIn(List<Integer> values) {
            addCriterion("id in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotIn(List<Integer> values) {
            addCriterion("id not in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdBetween(Integer value1, Integer value2) {
            addCriterion("id between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotBetween(Integer value1, Integer value2) {
            addCriterion("id not between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andCityIdIsNull() {
            addCriterion("city_id is null");
            return (Criteria) this;
        }

        public Criteria andCityIdIsNotNull() {
            addCriterion("city_id is not null");
            return (Criteria) this;
        }

        public Criteria andCityIdEqualTo(Integer value) {
            addCriterion("city_id =", value, "cityId");
            return (Criteria) this;
        }

        public Criteria andCityIdNotEqualTo(Integer value) {
            addCriterion("city_id <>", value, "cityId");
            return (Criteria) this;
        }

        public Criteria andCityIdGreaterThan(Integer value) {
            addCriterion("city_id >", value, "cityId");
            return (Criteria) this;
        }

        public Criteria andCityIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("city_id >=", value, "cityId");
            return (Criteria) this;
        }

        public Criteria andCityIdLessThan(Integer value) {
            addCriterion("city_id <", value, "cityId");
            return (Criteria) this;
        }

        public Criteria andCityIdLessThanOrEqualTo(Integer value) {
            addCriterion("city_id <=", value, "cityId");
            return (Criteria) this;
        }

        public Criteria andCityIdIn(List<Integer> values) {
            addCriterion("city_id in", values, "cityId");
            return (Criteria) this;
        }

        public Criteria andCityIdNotIn(List<Integer> values) {
            addCriterion("city_id not in", values, "cityId");
            return (Criteria) this;
        }

        public Criteria andCityIdBetween(Integer value1, Integer value2) {
            addCriterion("city_id between", value1, value2, "cityId");
            return (Criteria) this;
        }

        public Criteria andCityIdNotBetween(Integer value1, Integer value2) {
            addCriterion("city_id not between", value1, value2, "cityId");
            return (Criteria) this;
        }

        public Criteria andCityNameIsNull() {
            addCriterion("city_name is null");
            return (Criteria) this;
        }

        public Criteria andCityNameIsNotNull() {
            addCriterion("city_name is not null");
            return (Criteria) this;
        }

        public Criteria andCityNameEqualTo(String value) {
            addCriterion("city_name =", value, "cityName");
            return (Criteria) this;
        }

        public Criteria andCityNameNotEqualTo(String value) {
            addCriterion("city_name <>", value, "cityName");
            return (Criteria) this;
        }

        public Criteria andCityNameGreaterThan(String value) {
            addCriterion("city_name >", value, "cityName");
            return (Criteria) this;
        }

        public Criteria andCityNameGreaterThanOrEqualTo(String value) {
            addCriterion("city_name >=", value, "cityName");
            return (Criteria) this;
        }

        public Criteria andCityNameLessThan(String value) {
            addCriterion("city_name <", value, "cityName");
            return (Criteria) this;
        }

        public Criteria andCityNameLessThanOrEqualTo(String value) {
            addCriterion("city_name <=", value, "cityName");
            return (Criteria) this;
        }

        public Criteria andCityNameLike(String value) {
            addCriterion("city_name like", value, "cityName");
            return (Criteria) this;
        }

        public Criteria andCityNameNotLike(String value) {
            addCriterion("city_name not like", value, "cityName");
            return (Criteria) this;
        }

        public Criteria andCityNameIn(List<String> values) {
            addCriterion("city_name in", values, "cityName");
            return (Criteria) this;
        }

        public Criteria andCityNameNotIn(List<String> values) {
            addCriterion("city_name not in", values, "cityName");
            return (Criteria) this;
        }

        public Criteria andCityNameBetween(String value1, String value2) {
            addCriterion("city_name between", value1, value2, "cityName");
            return (Criteria) this;
        }

        public Criteria andCityNameNotBetween(String value1, String value2) {
            addCriterion("city_name not between", value1, value2, "cityName");
            return (Criteria) this;
        }

        public Criteria andF211IsNull() {
            addCriterion("f211 is null");
            return (Criteria) this;
        }

        public Criteria andF211IsNotNull() {
            addCriterion("f211 is not null");
            return (Criteria) this;
        }

        public Criteria andF211EqualTo(Integer value) {
            addCriterion("f211 =", value, "f211");
            return (Criteria) this;
        }

        public Criteria andF211NotEqualTo(Integer value) {
            addCriterion("f211 <>", value, "f211");
            return (Criteria) this;
        }

        public Criteria andF211GreaterThan(Integer value) {
            addCriterion("f211 >", value, "f211");
            return (Criteria) this;
        }

        public Criteria andF211GreaterThanOrEqualTo(Integer value) {
            addCriterion("f211 >=", value, "f211");
            return (Criteria) this;
        }

        public Criteria andF211LessThan(Integer value) {
            addCriterion("f211 <", value, "f211");
            return (Criteria) this;
        }

        public Criteria andF211LessThanOrEqualTo(Integer value) {
            addCriterion("f211 <=", value, "f211");
            return (Criteria) this;
        }

        public Criteria andF211In(List<Integer> values) {
            addCriterion("f211 in", values, "f211");
            return (Criteria) this;
        }

        public Criteria andF211NotIn(List<Integer> values) {
            addCriterion("f211 not in", values, "f211");
            return (Criteria) this;
        }

        public Criteria andF211Between(Integer value1, Integer value2) {
            addCriterion("f211 between", value1, value2, "f211");
            return (Criteria) this;
        }

        public Criteria andF211NotBetween(Integer value1, Integer value2) {
            addCriterion("f211 not between", value1, value2, "f211");
            return (Criteria) this;
        }

        public Criteria andF985IsNull() {
            addCriterion("f985 is null");
            return (Criteria) this;
        }

        public Criteria andF985IsNotNull() {
            addCriterion("f985 is not null");
            return (Criteria) this;
        }

        public Criteria andF985EqualTo(Integer value) {
            addCriterion("f985 =", value, "f985");
            return (Criteria) this;
        }

        public Criteria andF985NotEqualTo(Integer value) {
            addCriterion("f985 <>", value, "f985");
            return (Criteria) this;
        }

        public Criteria andF985GreaterThan(Integer value) {
            addCriterion("f985 >", value, "f985");
            return (Criteria) this;
        }

        public Criteria andF985GreaterThanOrEqualTo(Integer value) {
            addCriterion("f985 >=", value, "f985");
            return (Criteria) this;
        }

        public Criteria andF985LessThan(Integer value) {
            addCriterion("f985 <", value, "f985");
            return (Criteria) this;
        }

        public Criteria andF985LessThanOrEqualTo(Integer value) {
            addCriterion("f985 <=", value, "f985");
            return (Criteria) this;
        }

        public Criteria andF985In(List<Integer> values) {
            addCriterion("f985 in", values, "f985");
            return (Criteria) this;
        }

        public Criteria andF985NotIn(List<Integer> values) {
            addCriterion("f985 not in", values, "f985");
            return (Criteria) this;
        }

        public Criteria andF985Between(Integer value1, Integer value2) {
            addCriterion("f985 between", value1, value2, "f985");
            return (Criteria) this;
        }

        public Criteria andF985NotBetween(Integer value1, Integer value2) {
            addCriterion("f985 not between", value1, value2, "f985");
            return (Criteria) this;
        }

        public Criteria andProvinceIdIsNull() {
            addCriterion("province_id is null");
            return (Criteria) this;
        }

        public Criteria andProvinceIdIsNotNull() {
            addCriterion("province_id is not null");
            return (Criteria) this;
        }

        public Criteria andProvinceIdEqualTo(Integer value) {
            addCriterion("province_id =", value, "provinceId");
            return (Criteria) this;
        }

        public Criteria andProvinceIdNotEqualTo(Integer value) {
            addCriterion("province_id <>", value, "provinceId");
            return (Criteria) this;
        }

        public Criteria andProvinceIdGreaterThan(Integer value) {
            addCriterion("province_id >", value, "provinceId");
            return (Criteria) this;
        }

        public Criteria andProvinceIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("province_id >=", value, "provinceId");
            return (Criteria) this;
        }

        public Criteria andProvinceIdLessThan(Integer value) {
            addCriterion("province_id <", value, "provinceId");
            return (Criteria) this;
        }

        public Criteria andProvinceIdLessThanOrEqualTo(Integer value) {
            addCriterion("province_id <=", value, "provinceId");
            return (Criteria) this;
        }

        public Criteria andProvinceIdIn(List<Integer> values) {
            addCriterion("province_id in", values, "provinceId");
            return (Criteria) this;
        }

        public Criteria andProvinceIdNotIn(List<Integer> values) {
            addCriterion("province_id not in", values, "provinceId");
            return (Criteria) this;
        }

        public Criteria andProvinceIdBetween(Integer value1, Integer value2) {
            addCriterion("province_id between", value1, value2, "provinceId");
            return (Criteria) this;
        }

        public Criteria andProvinceIdNotBetween(Integer value1, Integer value2) {
            addCriterion("province_id not between", value1, value2, "provinceId");
            return (Criteria) this;
        }

        public Criteria andRankNumIsNull() {
            addCriterion("rank_num is null");
            return (Criteria) this;
        }

        public Criteria andRankNumIsNotNull() {
            addCriterion("rank_num is not null");
            return (Criteria) this;
        }

        public Criteria andRankNumEqualTo(String value) {
            addCriterion("rank_num =", value, "rankNum");
            return (Criteria) this;
        }

        public Criteria andRankNumNotEqualTo(String value) {
            addCriterion("rank_num <>", value, "rankNum");
            return (Criteria) this;
        }

        public Criteria andRankNumGreaterThan(String value) {
            addCriterion("rank_num >", value, "rankNum");
            return (Criteria) this;
        }

        public Criteria andRankNumGreaterThanOrEqualTo(String value) {
            addCriterion("rank_num >=", value, "rankNum");
            return (Criteria) this;
        }

        public Criteria andRankNumLessThan(String value) {
            addCriterion("rank_num <", value, "rankNum");
            return (Criteria) this;
        }

        public Criteria andRankNumLessThanOrEqualTo(String value) {
            addCriterion("rank_num <=", value, "rankNum");
            return (Criteria) this;
        }

        public Criteria andRankNumLike(String value) {
            addCriterion("rank_num like", value, "rankNum");
            return (Criteria) this;
        }

        public Criteria andRankNumNotLike(String value) {
            addCriterion("rank_num not like", value, "rankNum");
            return (Criteria) this;
        }

        public Criteria andRankNumIn(List<String> values) {
            addCriterion("rank_num in", values, "rankNum");
            return (Criteria) this;
        }

        public Criteria andRankNumNotIn(List<String> values) {
            addCriterion("rank_num not in", values, "rankNum");
            return (Criteria) this;
        }

        public Criteria andRankNumBetween(String value1, String value2) {
            addCriterion("rank_num between", value1, value2, "rankNum");
            return (Criteria) this;
        }

        public Criteria andRankNumNotBetween(String value1, String value2) {
            addCriterion("rank_num not between", value1, value2, "rankNum");
            return (Criteria) this;
        }

        public Criteria andRankTypeIsNull() {
            addCriterion("rank_type is null");
            return (Criteria) this;
        }

        public Criteria andRankTypeIsNotNull() {
            addCriterion("rank_type is not null");
            return (Criteria) this;
        }

        public Criteria andRankTypeEqualTo(Integer value) {
            addCriterion("rank_type =", value, "rankType");
            return (Criteria) this;
        }

        public Criteria andRankTypeNotEqualTo(Integer value) {
            addCriterion("rank_type <>", value, "rankType");
            return (Criteria) this;
        }

        public Criteria andRankTypeGreaterThan(Integer value) {
            addCriterion("rank_type >", value, "rankType");
            return (Criteria) this;
        }

        public Criteria andRankTypeGreaterThanOrEqualTo(Integer value) {
            addCriterion("rank_type >=", value, "rankType");
            return (Criteria) this;
        }

        public Criteria andRankTypeLessThan(Integer value) {
            addCriterion("rank_type <", value, "rankType");
            return (Criteria) this;
        }

        public Criteria andRankTypeLessThanOrEqualTo(Integer value) {
            addCriterion("rank_type <=", value, "rankType");
            return (Criteria) this;
        }

        public Criteria andRankTypeIn(List<Integer> values) {
            addCriterion("rank_type in", values, "rankType");
            return (Criteria) this;
        }

        public Criteria andRankTypeNotIn(List<Integer> values) {
            addCriterion("rank_type not in", values, "rankType");
            return (Criteria) this;
        }

        public Criteria andRankTypeBetween(Integer value1, Integer value2) {
            addCriterion("rank_type between", value1, value2, "rankType");
            return (Criteria) this;
        }

        public Criteria andRankTypeNotBetween(Integer value1, Integer value2) {
            addCriterion("rank_type not between", value1, value2, "rankType");
            return (Criteria) this;
        }

        public Criteria andSchoolIdIsNull() {
            addCriterion("school_id is null");
            return (Criteria) this;
        }

        public Criteria andSchoolIdIsNotNull() {
            addCriterion("school_id is not null");
            return (Criteria) this;
        }

        public Criteria andSchoolIdEqualTo(Integer value) {
            addCriterion("school_id =", value, "schoolId");
            return (Criteria) this;
        }

        public Criteria andSchoolIdNotEqualTo(Integer value) {
            addCriterion("school_id <>", value, "schoolId");
            return (Criteria) this;
        }

        public Criteria andSchoolIdGreaterThan(Integer value) {
            addCriterion("school_id >", value, "schoolId");
            return (Criteria) this;
        }

        public Criteria andSchoolIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("school_id >=", value, "schoolId");
            return (Criteria) this;
        }

        public Criteria andSchoolIdLessThan(Integer value) {
            addCriterion("school_id <", value, "schoolId");
            return (Criteria) this;
        }

        public Criteria andSchoolIdLessThanOrEqualTo(Integer value) {
            addCriterion("school_id <=", value, "schoolId");
            return (Criteria) this;
        }

        public Criteria andSchoolIdIn(List<Integer> values) {
            addCriterion("school_id in", values, "schoolId");
            return (Criteria) this;
        }

        public Criteria andSchoolIdNotIn(List<Integer> values) {
            addCriterion("school_id not in", values, "schoolId");
            return (Criteria) this;
        }

        public Criteria andSchoolIdBetween(Integer value1, Integer value2) {
            addCriterion("school_id between", value1, value2, "schoolId");
            return (Criteria) this;
        }

        public Criteria andSchoolIdNotBetween(Integer value1, Integer value2) {
            addCriterion("school_id not between", value1, value2, "schoolId");
            return (Criteria) this;
        }

        public Criteria andSchoolNameIsNull() {
            addCriterion("school_name is null");
            return (Criteria) this;
        }

        public Criteria andSchoolNameIsNotNull() {
            addCriterion("school_name is not null");
            return (Criteria) this;
        }

        public Criteria andSchoolNameEqualTo(String value) {
            addCriterion("school_name =", value, "schoolName");
            return (Criteria) this;
        }

        public Criteria andSchoolNameNotEqualTo(String value) {
            addCriterion("school_name <>", value, "schoolName");
            return (Criteria) this;
        }

        public Criteria andSchoolNameGreaterThan(String value) {
            addCriterion("school_name >", value, "schoolName");
            return (Criteria) this;
        }

        public Criteria andSchoolNameGreaterThanOrEqualTo(String value) {
            addCriterion("school_name >=", value, "schoolName");
            return (Criteria) this;
        }

        public Criteria andSchoolNameLessThan(String value) {
            addCriterion("school_name <", value, "schoolName");
            return (Criteria) this;
        }

        public Criteria andSchoolNameLessThanOrEqualTo(String value) {
            addCriterion("school_name <=", value, "schoolName");
            return (Criteria) this;
        }

        public Criteria andSchoolNameLike(String value) {
            addCriterion("school_name like", value, "schoolName");
            return (Criteria) this;
        }

        public Criteria andSchoolNameNotLike(String value) {
            addCriterion("school_name not like", value, "schoolName");
            return (Criteria) this;
        }

        public Criteria andSchoolNameIn(List<String> values) {
            addCriterion("school_name in", values, "schoolName");
            return (Criteria) this;
        }

        public Criteria andSchoolNameNotIn(List<String> values) {
            addCriterion("school_name not in", values, "schoolName");
            return (Criteria) this;
        }

        public Criteria andSchoolNameBetween(String value1, String value2) {
            addCriterion("school_name between", value1, value2, "schoolName");
            return (Criteria) this;
        }

        public Criteria andSchoolNameNotBetween(String value1, String value2) {
            addCriterion("school_name not between", value1, value2, "schoolName");
            return (Criteria) this;
        }

        public Criteria andTypeIsNull() {
            addCriterion("type is null");
            return (Criteria) this;
        }

        public Criteria andTypeIsNotNull() {
            addCriterion("type is not null");
            return (Criteria) this;
        }

        public Criteria andTypeEqualTo(Integer value) {
            addCriterion("type =", value, "type");
            return (Criteria) this;
        }

        public Criteria andTypeNotEqualTo(Integer value) {
            addCriterion("type <>", value, "type");
            return (Criteria) this;
        }

        public Criteria andTypeGreaterThan(Integer value) {
            addCriterion("type >", value, "type");
            return (Criteria) this;
        }

        public Criteria andTypeGreaterThanOrEqualTo(Integer value) {
            addCriterion("type >=", value, "type");
            return (Criteria) this;
        }

        public Criteria andTypeLessThan(Integer value) {
            addCriterion("type <", value, "type");
            return (Criteria) this;
        }

        public Criteria andTypeLessThanOrEqualTo(Integer value) {
            addCriterion("type <=", value, "type");
            return (Criteria) this;
        }

        public Criteria andTypeIn(List<Integer> values) {
            addCriterion("type in", values, "type");
            return (Criteria) this;
        }

        public Criteria andTypeNotIn(List<Integer> values) {
            addCriterion("type not in", values, "type");
            return (Criteria) this;
        }

        public Criteria andTypeBetween(Integer value1, Integer value2) {
            addCriterion("type between", value1, value2, "type");
            return (Criteria) this;
        }

        public Criteria andTypeNotBetween(Integer value1, Integer value2) {
            addCriterion("type not between", value1, value2, "type");
            return (Criteria) this;
        }

        public Criteria andTypeNameIsNull() {
            addCriterion("type_name is null");
            return (Criteria) this;
        }

        public Criteria andTypeNameIsNotNull() {
            addCriterion("type_name is not null");
            return (Criteria) this;
        }

        public Criteria andTypeNameEqualTo(String value) {
            addCriterion("type_name =", value, "typeName");
            return (Criteria) this;
        }

        public Criteria andTypeNameNotEqualTo(String value) {
            addCriterion("type_name <>", value, "typeName");
            return (Criteria) this;
        }

        public Criteria andTypeNameGreaterThan(String value) {
            addCriterion("type_name >", value, "typeName");
            return (Criteria) this;
        }

        public Criteria andTypeNameGreaterThanOrEqualTo(String value) {
            addCriterion("type_name >=", value, "typeName");
            return (Criteria) this;
        }

        public Criteria andTypeNameLessThan(String value) {
            addCriterion("type_name <", value, "typeName");
            return (Criteria) this;
        }

        public Criteria andTypeNameLessThanOrEqualTo(String value) {
            addCriterion("type_name <=", value, "typeName");
            return (Criteria) this;
        }

        public Criteria andTypeNameLike(String value) {
            addCriterion("type_name like", value, "typeName");
            return (Criteria) this;
        }

        public Criteria andTypeNameNotLike(String value) {
            addCriterion("type_name not like", value, "typeName");
            return (Criteria) this;
        }

        public Criteria andTypeNameIn(List<String> values) {
            addCriterion("type_name in", values, "typeName");
            return (Criteria) this;
        }

        public Criteria andTypeNameNotIn(List<String> values) {
            addCriterion("type_name not in", values, "typeName");
            return (Criteria) this;
        }

        public Criteria andTypeNameBetween(String value1, String value2) {
            addCriterion("type_name between", value1, value2, "typeName");
            return (Criteria) this;
        }

        public Criteria andTypeNameNotBetween(String value1, String value2) {
            addCriterion("type_name not between", value1, value2, "typeName");
            return (Criteria) this;
        }

        public Criteria andCountryIdIsNull() {
            addCriterion("country_id is null");
            return (Criteria) this;
        }

        public Criteria andCountryIdIsNotNull() {
            addCriterion("country_id is not null");
            return (Criteria) this;
        }

        public Criteria andCountryIdEqualTo(Integer value) {
            addCriterion("country_id =", value, "countryId");
            return (Criteria) this;
        }

        public Criteria andCountryIdNotEqualTo(Integer value) {
            addCriterion("country_id <>", value, "countryId");
            return (Criteria) this;
        }

        public Criteria andCountryIdGreaterThan(Integer value) {
            addCriterion("country_id >", value, "countryId");
            return (Criteria) this;
        }

        public Criteria andCountryIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("country_id >=", value, "countryId");
            return (Criteria) this;
        }

        public Criteria andCountryIdLessThan(Integer value) {
            addCriterion("country_id <", value, "countryId");
            return (Criteria) this;
        }

        public Criteria andCountryIdLessThanOrEqualTo(Integer value) {
            addCriterion("country_id <=", value, "countryId");
            return (Criteria) this;
        }

        public Criteria andCountryIdIn(List<Integer> values) {
            addCriterion("country_id in", values, "countryId");
            return (Criteria) this;
        }

        public Criteria andCountryIdNotIn(List<Integer> values) {
            addCriterion("country_id not in", values, "countryId");
            return (Criteria) this;
        }

        public Criteria andCountryIdBetween(Integer value1, Integer value2) {
            addCriterion("country_id between", value1, value2, "countryId");
            return (Criteria) this;
        }

        public Criteria andCountryIdNotBetween(Integer value1, Integer value2) {
            addCriterion("country_id not between", value1, value2, "countryId");
            return (Criteria) this;
        }

        public Criteria andCountryNameIsNull() {
            addCriterion("country_name is null");
            return (Criteria) this;
        }

        public Criteria andCountryNameIsNotNull() {
            addCriterion("country_name is not null");
            return (Criteria) this;
        }

        public Criteria andCountryNameEqualTo(String value) {
            addCriterion("country_name =", value, "countryName");
            return (Criteria) this;
        }

        public Criteria andCountryNameNotEqualTo(String value) {
            addCriterion("country_name <>", value, "countryName");
            return (Criteria) this;
        }

        public Criteria andCountryNameGreaterThan(String value) {
            addCriterion("country_name >", value, "countryName");
            return (Criteria) this;
        }

        public Criteria andCountryNameGreaterThanOrEqualTo(String value) {
            addCriterion("country_name >=", value, "countryName");
            return (Criteria) this;
        }

        public Criteria andCountryNameLessThan(String value) {
            addCriterion("country_name <", value, "countryName");
            return (Criteria) this;
        }

        public Criteria andCountryNameLessThanOrEqualTo(String value) {
            addCriterion("country_name <=", value, "countryName");
            return (Criteria) this;
        }

        public Criteria andCountryNameLike(String value) {
            addCriterion("country_name like", value, "countryName");
            return (Criteria) this;
        }

        public Criteria andCountryNameNotLike(String value) {
            addCriterion("country_name not like", value, "countryName");
            return (Criteria) this;
        }

        public Criteria andCountryNameIn(List<String> values) {
            addCriterion("country_name in", values, "countryName");
            return (Criteria) this;
        }

        public Criteria andCountryNameNotIn(List<String> values) {
            addCriterion("country_name not in", values, "countryName");
            return (Criteria) this;
        }

        public Criteria andCountryNameBetween(String value1, String value2) {
            addCriterion("country_name between", value1, value2, "countryName");
            return (Criteria) this;
        }

        public Criteria andCountryNameNotBetween(String value1, String value2) {
            addCriterion("country_name not between", value1, value2, "countryName");
            return (Criteria) this;
        }

        public Criteria andContinentIdIsNull() {
            addCriterion("continent_id is null");
            return (Criteria) this;
        }

        public Criteria andContinentIdIsNotNull() {
            addCriterion("continent_id is not null");
            return (Criteria) this;
        }

        public Criteria andContinentIdEqualTo(Integer value) {
            addCriterion("continent_id =", value, "continentId");
            return (Criteria) this;
        }

        public Criteria andContinentIdNotEqualTo(Integer value) {
            addCriterion("continent_id <>", value, "continentId");
            return (Criteria) this;
        }

        public Criteria andContinentIdGreaterThan(Integer value) {
            addCriterion("continent_id >", value, "continentId");
            return (Criteria) this;
        }

        public Criteria andContinentIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("continent_id >=", value, "continentId");
            return (Criteria) this;
        }

        public Criteria andContinentIdLessThan(Integer value) {
            addCriterion("continent_id <", value, "continentId");
            return (Criteria) this;
        }

        public Criteria andContinentIdLessThanOrEqualTo(Integer value) {
            addCriterion("continent_id <=", value, "continentId");
            return (Criteria) this;
        }

        public Criteria andContinentIdIn(List<Integer> values) {
            addCriterion("continent_id in", values, "continentId");
            return (Criteria) this;
        }

        public Criteria andContinentIdNotIn(List<Integer> values) {
            addCriterion("continent_id not in", values, "continentId");
            return (Criteria) this;
        }

        public Criteria andContinentIdBetween(Integer value1, Integer value2) {
            addCriterion("continent_id between", value1, value2, "continentId");
            return (Criteria) this;
        }

        public Criteria andContinentIdNotBetween(Integer value1, Integer value2) {
            addCriterion("continent_id not between", value1, value2, "continentId");
            return (Criteria) this;
        }

        public Criteria andContinentNameIsNull() {
            addCriterion("continent_name is null");
            return (Criteria) this;
        }

        public Criteria andContinentNameIsNotNull() {
            addCriterion("continent_name is not null");
            return (Criteria) this;
        }

        public Criteria andContinentNameEqualTo(String value) {
            addCriterion("continent_name =", value, "continentName");
            return (Criteria) this;
        }

        public Criteria andContinentNameNotEqualTo(String value) {
            addCriterion("continent_name <>", value, "continentName");
            return (Criteria) this;
        }

        public Criteria andContinentNameGreaterThan(String value) {
            addCriterion("continent_name >", value, "continentName");
            return (Criteria) this;
        }

        public Criteria andContinentNameGreaterThanOrEqualTo(String value) {
            addCriterion("continent_name >=", value, "continentName");
            return (Criteria) this;
        }

        public Criteria andContinentNameLessThan(String value) {
            addCriterion("continent_name <", value, "continentName");
            return (Criteria) this;
        }

        public Criteria andContinentNameLessThanOrEqualTo(String value) {
            addCriterion("continent_name <=", value, "continentName");
            return (Criteria) this;
        }

        public Criteria andContinentNameLike(String value) {
            addCriterion("continent_name like", value, "continentName");
            return (Criteria) this;
        }

        public Criteria andContinentNameNotLike(String value) {
            addCriterion("continent_name not like", value, "continentName");
            return (Criteria) this;
        }

        public Criteria andContinentNameIn(List<String> values) {
            addCriterion("continent_name in", values, "continentName");
            return (Criteria) this;
        }

        public Criteria andContinentNameNotIn(List<String> values) {
            addCriterion("continent_name not in", values, "continentName");
            return (Criteria) this;
        }

        public Criteria andContinentNameBetween(String value1, String value2) {
            addCriterion("continent_name between", value1, value2, "continentName");
            return (Criteria) this;
        }

        public Criteria andContinentNameNotBetween(String value1, String value2) {
            addCriterion("continent_name not between", value1, value2, "continentName");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    /**
     * 
     * 
     * @author wcyong
     * 
     * @date 2019-06-14
     */
    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}